Week Of: 2021-11-28
2021-11-30

home/Professional

SQLite basics #

Install #

go to: Precompiled Binaries for Windows in: https://www.sqlite.org/download.html
and download the file.

locate the sqlite3 file in your preffered directory.

Start using #

there you should run the command:

sqlite3 kanban.db

where the kanban.db is the db binary file.

Basic Help #

.help

Export the next command to Excel file #

.excel --bom

where the --bom is for the Hebrew characters (UTF-8)

Show your all tables #

.tables

SQL Commands #

select * from card;